package com.work.dao;

import com.work.bean.Student;
import com.work.bean.StudentDTO;

import java.util.List;

public interface StudentDao {

    //插入方法  add
    public int addStu(Student stu) throws Exception;

    //修改方法 entity
    public int uptStu(Student stu) throws Exception;

    //删除方法 del
    public int delStu(int sid) throws Exception;

    //全查询方法 find
    public List<Student> selectAll() throws Exception;

    //查询名字字段（一列）
    public List<String> findSnameList() throws Exception;

    //根据id查信息（一行）
    public Student findStuById(String sid) throws Exception;

    //查询人数（一行一列）
    public int findCount() throws Exception;

    //动态查询
    public List<Student> findPramStu(String sid, String sname, String ssex) throws Exception;

    //连表模糊查询
    public List<Student> findScoreStu(StudentDTO studentDTO) throws Exception;
}
